2015-03-10 - 17812.300 - Spec - FICO Japan Automatic payment program for Retail #JapanABAP #JapanFICO
SPECIFICATIONS
17812.300 - FICO Automatic Payment Program For Retail
Purpose
The Japan POS system will provide information in certain format and a customized program should be developed to read this information and create payment transactions based on the data extract from POS system.
Admin Info
Purpose
|
FICO Automatic payment program for Retail
|
Requested By
|
Jingsha
|
Spec Created By
|
Prudvi/Mahesh
|
Spec Created Date
|
08/10/2014
|
Spec QA by
|
Jingsha
|
Objects
|
ZJAPAN_PAYMENTS
ZFI_JPPOS_PYMT
ZFI_JPPOS_CUS
|
Document Status
|
Completed
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
10
|
5
|
Unit test in QUA
|
10
|
6
|
Other activity
|
10
|
|
TOTAL
|
78
|
References
NA
Documents
[Attach any document(s) received for the requirement(s)]
SIT0120131023001450 (3).TXT
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
001
|
Manual Posting date Field or Automatic Document date as Posting Date from Flat file
|
Jingsha
|
01/05/2015
|
|
002
|
GL Account wrongly picking from the table as the font miss match with table and in flat file
|
Jingsha
|
01/15/2015
|
|
003
|
Text is missing in the FI entry for multiple payments for a single reference
|
Jingsha
|
01/15/2015
|
|
004
|
Create a new T.code ZJP_POS_PY for the program ZJAPAN_PAYMENTS.
|
Jingsha
|
03/10/2015
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
The Japan POS system will provide information in certain format and a customized program should be developed to read this information and create payment transactions based on the data extract from POS system.
-Add Manual Posting date field and automatic Document date as Posting Date if posting date not manually entered
-GL Account should should be updated as per the table ZFI_JPPOS_PYMT with reference to POS System
-Text field should update with respective of the payments
1) Option for manual entry for posting date field and automatically pick the document date as posting date for flat file if posting date not entered manually
2) Create a new T.code ZJP_POS_PY for the program ZJAPAN_PAYMENTS.
In Scope:
[List the
activities to be included in scope]
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
A customize SAP program is needed in order to obtain the necessary information from the upload files and create payment documents in SAP.
-Posting field should be add in the program and necessary changes have to be done in the program for Document date as posting date
-Irrespective of font in the table and the upload file the right GL account should pick from the table
-Text field update as per the upload file from POS system
1) If the date entered in Posting date field then system will take the given date in the entry else it will take from flat file.
2) New T.code ZJP_POS_PY for program ZJAPAN_PAYMENTS.
Test Data
New Posting date field
Test ID
|
Test Scenario
|
Expected Results
|
FI-001
|
Japan retail payment program with Manual posting date
|
Manual entered Posting date should update in the payment program
|
FI-002
|
Japan retail payment program without Manual posting date
|
Posting date should be automatically taken from the flat file
|
Document Text and GL account correct update
Test ID
|
Test Scenario
|
Expected Results
|
FI-001
|
Japan retail payment program with Manual posting date
|
Actual GL account should pick irrespective of Font from the table and Document Text should be updated for the payments in the payment program
|
FI-002
|
Japan retail payment program with Manual posting date
|
Actual GL account should pick irrespective of Font from the table and Document Text should be updated for the payments in the payment program
|
FI-003
|
Japan retail payment program without Manual posting date
|
Actual GL account should pick irrespective of Font from the table and Document Text should be updated for the payments in the
payment program
|
New T.code ZJP_POS_PY
Test ID
|
Test Scenario
|
Expected Results
|
FI-001
|
Japan T.code ZJP_POS_PY for retail payments from the flat file
|
Entries should update as given in the flat file and Posting should be automatically update from flat file.
|
FI-002
|
Japan T.code ZJP_POS_PY for retail payments from the flat file with manual entry Posting Date
|
Entries should update as given in the flat file and Posting should update as per the manual entry
|
Solution Details
[Provide complete technical details for configuration or programming here]
A customize SAP program is needed in order to obtain the necessary information from the upload files and create payment documents in SAP.
The File could contain multiple items for the same reference/Invoice number,payment creation only need to create one payment per transaction and create invoice subtotal before creating the payment.
- The Customer account number is determined based on the first 4 characters (store ID) of the SIT file. Mapping of the store ID - Customer number will be maintained in the customized table 2
- The cash GL account or Bank account will be determined by the tender type. GL-Tender type mapping will be maintained in the customized table 1.
- Developed two custom tables to maintain one for G/L account and 2 is customer store ID
This program should trigger based on below conditions,
- ** If the Subtotal of each ID (Subtotal of each Invoice number)is >= 0, the document creation program should be based on tcode F-28.
- If the Subtotal of each ID is < 0, the document creation program should be based on tcode F-53.
F-28 and F-53 are very similar with small differences. In F-53, some default fields need to be overwritten by the program, such as Document type and Account type.
1. Added screen field for Manual Posting date and changed the logic to post the document with the Manual posting date in case the date is filled else it will take from flat file.
2. Created a New T.code ZJP_POS_PY
1. Added logic to populate the text field details in the final posting table
2. Changed the logic to pick up the Correct GL Account
Issues
[List Issues / Bugs identified in configuration or development]
1) Text field is missing for multiple entries in the flat file.
2) Picking the wrong GL account from the ZFI_JPPOS_PYMT table.